Electricity Consumption Report

Prepared By: Zahiruddin Zahidanishah

Introduction

This report reports shows the electricity consumption and amount payable for a typical double storey house in urban city located in Selangor, Malaysia. This report consists of data from year 2014 to date. This report will shows the relation between the consumption and payment for the electricity usage every month and every year.

The details of the house inventory and areas are as describe belows.

Assets Details
  Items Description
0 Type Double Storey Terrace House
1 Land Area (sq.m) 121
2 Build Up Area (sq.m) 180
3 Bedrooms 4
4 Bathrooms 3
5 Lighting Pts. 22
6 Power Pts. 14
7 Fan Pts. 4
8 AC Pts. 3
Summary of Annual Electriciy Consumption
Year Total Usage (kWh) Total Amount (RM) Electricity Rate (RM/kWh) Ave. Usage (kWh) Ave. Amount (RM) Ave. Usage/P (kWh/p) Ave. Usage/A (kWh/m2) Max. Usage (kWh) Max. Amount (RM)
2014 3645 964 0.26 303 80 60 1 350 102
2015 3569 899 0.25 297 74 59 1 405 103
2016 4498 1365 0.30 374 113 74 2 530 188
2017 4719 1491 0.32 393 124 78 2 448 153
2018 4640 1439 0.31 386 119 77 2 490 175
2019 4249 1278 0.30 354 106 70 1 444 151
2020 5080 1240 0.24 423 103 84 2 1221 164
2021 4596 1326 0.29 383 110 76 2 444 136
2022 1826 524 0.29 365 104 30 0 460 152

Detail of Consumption (kWh) and Amount (RM) for Every Years From 2014 to 2020

Monthly Electricity Usage (kWh)
Months 2014 2015 2016 2017 2018 2019 2020 2021 2022
Jan 261 254 246 427 342 370 355 322 359
Feb 288 347 399 390 455 444 314 378 323
Mac 348 276 530 448 426 399 350 378 384
Apr 263 309 465 441 419 373 350 361 460
May 350 301 494 361 490 413 350 357 300
Jun 324 273 342 393 315 285 1221 393 nan
Jul 346 405 305 339 357 366 368 361 nan
Aug 268 238 409 383 412 280 344 436 nan
Sep 292 295 336 399 389 348 360 396 nan
Oct 267 266 378 406 358 336 336 444 nan
Nov 301 321 286 405 368 323 391 404 nan
Dec 337 284 308 327 309 312 341 366 nan
Monthly Electricity Cost (RM)
Months 2014 2015 2016 2017 2018 2019 2020 2021 2022
Jan 64 62 59 143 99 113 107 80 102
Feb 71 87 120 123 149 151 86 112 84
Mac 102 69 188 153 142 130 104 112 115
Apr 65 82 162 150 138 116 96 103 153
May 103 78 177 108 175 137 89 101 71
Jun 89 68 99 125 79 72 164 119 nan
Jul 101 104 80 92 106 113 112 103 nan
Aug 66 56 125 120 135 70 100 122 nan
Sep 74 75 88 123 115 103 108 109 nan
Oct 66 66 117 132 107 97 83 137 nan
Nov 78 82 72 131 112 90 107 125 nan
Dec 86 72 78 91 82 84 85 106 nan
Monthly Electricity Rates (kWh/p)
Months 2014 2015 2016 2017 2018 2019 2020 2021 2022
Jan 52 51 49 85 68 74 71 64 72
Feb 58 69 80 78 91 89 63 76 65
Mac 70 55 106 90 85 80 70 76 77
Apr 53 62 93 88 84 75 70 72 92
May 70 60 99 72 98 83 70 71 60
Jun 65 55 68 79 63 57 244 79 nan
Jul 69 81 61 68 71 73 74 72 nan
Aug 54 48 82 77 82 56 69 87 nan
Sep 58 59 67 80 78 70 72 79 nan
Oct 53 53 76 81 72 67 67 89 nan
Nov 60 64 57 81 74 65 78 81 nan
Dec 67 57 62 65 62 62 68 73 nan

Note:

  1. This report is prepared by Zahiruddin Zahidanishah. This report is only for educational purposed and shall not be used for any commercial purposed.
  2. This report is prepared using open source application such as Jupyter Notebook, Python, Plotly, Pandas and etc.